/*
{
"状态":1,
"名称":"获取广告屏信息-根据硬件信息获取广告屏信息",
"作者":"谌舜谋",
"创建时间":"2018-10-13",
"功能":"获取广告屏信息-根据硬件信息获取广告屏信息",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/

declare @hardwareinfo varchar(200)
set @hardwareinfo ='{hardwareinfo}'
if not exists(select * from b_ad_screen where hardwareinfo = @hardwareinfo)
	begin
			RAISERROR ('SQL:硬件信息不存在', 16 ,1 ) ; 
			return 
	end
 select * from b_ad_screen where hardwareinfo = @hardwareinfo
 